Counts empty cells in a specified range of cells.
Syntax
COUNTBLANK(range)
Range is the range from which you want to count the blank cells.
Remark
Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.
Example
The example may be easier to understand if you copy it to a blank spreadsheet.
Selecting an example from Help
Data | Data |
---|---|
6 | =IF(B4<30,"",B4) |
27 | |
4 | 34 |
Formula | Description (Result) |
=COUNTBLANK(A2:B5) | Counts empty cells in the range above. The formula returns the number of empty text cells. (3) |